Datenbänke |

Diese Information ist nur relevant wenn Sie eine Lizenz Fisa Logger besitzen. Siehe Fisa Logger

Datenbänke
Logger Master.cmb
Logger.cmb
Struktur
How Data are Created and Saved
Abfragen
Beispiel Abfrage
Datenbänke

Fisa Logger databases have the extension *.cmb. Dateiextensionen

These databases are only used for saving Production data with Fisa Logger License.

Die Datenbänke können mit Access 2000(in Microsoft Office 2000 Professional or later)geöffnet werden. By default, the databases are password protected. Sie können das Kennwort ändern oder entfernen. Wie das Kennwort geändert wird

Fisa Logger arbeitet mit zwei Datenbänken:

- Logger Master.cmb
- Logger.cmb

  Logger Master serves as the template for creating a new Installation.cmb (working database). Logger.cmb will be named as your Installation name, eg My First Installation.cmb. The structure of the Logger.cmb will therefore be the same as for Logger Master.cmb, except for the table Operators which exists only in the Logger Master.cmb.
  Logger Master.cmb

  Located in the application path

  Sie müssen das Kennwort für Logger Master.cmb kennen, um in Administratorebene hereinzukommen. Administratorebene
  Logger.cmb

  Located in the same path as the *.cmg file.
  Normalerweise \Fisa Software\Fisa Project\Installations\MyFirst Installation.cmb.
  Dateiextensionen

  This database is created as a copy of Logger Master.cmb whenever creating a new installation. The Logger.cmb could also be created if it is not found at the same location as the *.cmg file.

  The Logger.cmb can have a different password than the one in Logger Master.cmb.
  Struktur

  How Data are Created and Saved

  - When an operator presses Start Logger and logging starts, a new Session is created. Logger starten
  - During the session different events create new data objects:
    1. Ein Korb wird auf einer Ladenposition ermittelt - stellt einen neuen Korb her.
    2. Ein Korb wird in eine Position eingesetzt - verursacht einen neuen Besuch. Besucherdetails
    3. Der Bediener klickt an das Eingriffemenü - verursacht eine neue Intervention. Wie man ein Eingriff registriert
    4. An instrument reports an offrange value - creates a new Alarm Object.
    5. A maintenance becomes due - creates a new Alarm Object.
  - Basket Objects and their corresponding Visits are saved whenever the Basket is put on an Unloading Position.
  - Alarms are continously saved.
  - Eingriffe werden gespeichert, während sie definiert werden.
  - Times of Activation of Accessories connected to Physical Outputs are registered for each visit. Siehe auch Ausgangsanschlüsse
  Abfragen

  The most important queries for data mining in the Logger database are already included in Fisa Logger. Der Korbanalysator

  This does not exclude that you might want to prepare your own, more refined, queries based on the stucture described above.
  Beispiel Abfrage

  A query like this one is easily constructed in the Access 2000 Query design interface:

  The produced SQL string looks like this:

  SELECT Baskets.*, Baskets.Barcode FROM ((Operators INNER JOIN [Session] ON Operators.Operator = Session.Operator) INNER JOIN Baskets ON Session.Counter = Baskets.SessionID) INNER JOIN Visits ON Baskets.Counter = Visits.BasketsID WHERE (((Baskets.Barcode) Like "????###AB*"));